UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KgS9SIoy20eJ/OEvh8ELpnt46hgxIigczhoX5XLfaP8='
WHERE
key_id = '273f8e4e9af7f95257d802118febb6489735dd5a78c22d186a8b88a774af3b4f'
AND (
token = 'KgS9SIoy20eJ/OEvh8ELpnt46hgxIigczhoX5XLfaP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)