UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd1HalPyyhqj78RCNXlrbrsB/WmlXItbcYt+ysl+z+HI='
WHERE
key_id = 'd5344363545a1fc3ef4e96eac0aa9ed177cb1ba8343e845d97fafadc8d5bed12'
AND (
token = 'd1HalPyyhqj78RCNXlrbrsB/WmlXItbcYt+ysl+z+HI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)