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