UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EEI8GN6enyCRDCFxZCgt0Fu4YHqdKj7oIvwtc84rhl4='
WHERE
key_id = 'ef672f43062e851335961da4bf70066e14f84bb50bb78f33ca4615c3fe5e4dce'
AND (
token = 'EEI8GN6enyCRDCFxZCgt0Fu4YHqdKj7oIvwtc84rhl4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)