UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JPWZ052rNVbbVYEL83s9MCAY75kiWWNNSTO3D4D4Rf8='
WHERE
key_id = 'd4ea693b37a52c380bc24d3d3d6321391f19b15d9bf3171ca226e8647ca28fe1'
AND (
token = 'JPWZ052rNVbbVYEL83s9MCAY75kiWWNNSTO3D4D4Rf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)