UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '913xjTSwV3PZX/840KfBCv0iDwiIQngrOZogob8Y+aw='
WHERE
key_id = 'cff4a5a1e9f03c570c7a9b23ffed9441682a59fcd631c5d767b5809aa3b2b735'
AND (
token = '913xjTSwV3PZX/840KfBCv0iDwiIQngrOZogob8Y+aw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)