UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3VwbkI5tjtgnYY4B6zYeYJBYMRFLmiixy/nZW4WLsmw='
WHERE
key_id = '1a24b9e0efcfc36c524bed9fa1dcb7e5a946ba0087be8483411d0501f08448a7'
AND (
token = '3VwbkI5tjtgnYY4B6zYeYJBYMRFLmiixy/nZW4WLsmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)