UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NHfyoJj57GtgH2hiOA/yix8bGv8UhLiox/fyaBvGvMQ='
WHERE
key_id = '2424608c5b39aeb9faf79e71b605aa02a16a262b325c13e2a64e53747de9c85e'
AND (
token = 'NHfyoJj57GtgH2hiOA/yix8bGv8UhLiox/fyaBvGvMQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)