UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zncf0sHgzBIdGkQIDuOYQ3TxM0mlboKbod5R93cgeYA='
WHERE
key_id = '77cadb0b99a86bd0ace53fc31c02bf16aec3333a990e273041a8a9c439cb6773'
AND (
token = 'zncf0sHgzBIdGkQIDuOYQ3TxM0mlboKbod5R93cgeYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)