UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4yfMAQ+/lziD5+Tr9nPN0zHdroq2zrwnpUORcmLsVfw='
WHERE
key_id = '365dc4983427dcb65c66f75a8e4e55fd680ab77774d750628752ff9544606a1f'
AND (
token = '4yfMAQ+/lziD5+Tr9nPN0zHdroq2zrwnpUORcmLsVfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)