UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zBVo0+tAQwFbmAJd3/5fSKmLhm310Whv1GzTG02fcuQ='
WHERE
key_id = '15c83966216264d6b6002145d61bbffe42998a74dd623fc7340894bcc494ac75'
AND (
token = 'zBVo0+tAQwFbmAJd3/5fSKmLhm310Whv1GzTG02fcuQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)