UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZTaLiIASgkyHHr/FykHWoAaxKGyp3KQCiw6u9xgErmY='
WHERE
key_id = 'c7be76c50f631215d396b98ef11eff1478edc7ff88154507cb9998cfa9c653d2'
AND (
token = 'ZTaLiIASgkyHHr/FykHWoAaxKGyp3KQCiw6u9xgErmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)