UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mnOSstu+9KGlXJoQj17Vi1LINzaxP8O3ZQkB8Iut54U='
WHERE
key_id = 'f6fd85a6c4e1ff2a1598de8f67178f947ef908a55be893afd26072ddcd427fcd'
AND (
token = 'mnOSstu+9KGlXJoQj17Vi1LINzaxP8O3ZQkB8Iut54U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)