UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7aj9D7mJw7Uor9wM0OfyWGAY1jm0Jhdjf/eXfYn4r5Y='
WHERE
key_id = '4ea78afd19004791044ac61da3a89d7455aafdf51d79c7c7d5c49d9e12104a7f'
AND (
token = '7aj9D7mJw7Uor9wM0OfyWGAY1jm0Jhdjf/eXfYn4r5Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)