UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G4zL1IhTH9QT7uPlPKdd6FDULIQPe8Be+t5kw4eDP78='
WHERE
key_id = '448b2776a6e8fce58fb60645589b3adefeb07565be9c0b2563c2bf6f89a6a6bb'
AND (
token = 'G4zL1IhTH9QT7uPlPKdd6FDULIQPe8Be+t5kw4eDP78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)