UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1G/pY4wiDnhD/UkM1B5RKULlr+sz5DZAZ5vogLFzn8A='
WHERE
key_id = 'c8ac0e651ce12e224c3ed61b3285e31b512cc925607c326205d3a96076da009d'
AND (
token = '1G/pY4wiDnhD/UkM1B5RKULlr+sz5DZAZ5vogLFzn8A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)