UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D6rVoHNRI3DqSjYGyonjytdoYrHfM24suuVkPuH8Tvw='
WHERE
key_id = '799fe3ef4c97b309e3c64829e4e7c5a90e1bd26142bb9c0edec27b50a5fe7bc9'
AND (
token = 'D6rVoHNRI3DqSjYGyonjytdoYrHfM24suuVkPuH8Tvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)