UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zn7ITW/n0c1gpW3Y/sICqTuHWw1i+quRNod5bFH4l8Y='
WHERE
key_id = '34af70a070836c6c81dadaa3a71fbefb8c12ca5225840b2131a34df34f0e0207'
AND (
token = 'zn7ITW/n0c1gpW3Y/sICqTuHWw1i+quRNod5bFH4l8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)