UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bkCQ8Ge/qUEP00SEZ3C3SMmky0jrtw3E1zJer8bsIK4='
WHERE
key_id = 'd8a6b6d703945e50bb4bce70fbd4c0412ad94132d9ff0da6a59a7af137737e2b'
AND (
token = 'bkCQ8Ge/qUEP00SEZ3C3SMmky0jrtw3E1zJer8bsIK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)