UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gW3s42XlI7V1xzb/dV0P2afTulr9b8DAmiIDD8XO7/E='
WHERE
key_id = 'f4f4f3f7883687f5eb92c14a1f37cc075941035cf09986d1432e6c7a69e5467e'
AND (
token = 'gW3s42XlI7V1xzb/dV0P2afTulr9b8DAmiIDD8XO7/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)