UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oTQoyB2jDB9wrr43gsD8cXsgPd+9Z20LLjKLjvztLXo='
WHERE
key_id = 'd40e6255a87eb4ae11b4ac1091cecaae4591b29d33867e69eaa8944aabc4fd68'
AND (
token = 'oTQoyB2jDB9wrr43gsD8cXsgPd+9Z20LLjKLjvztLXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)