UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2CxJe1U+cIRDYhccbgDUqrZJ59dPtFc/hq4apG42/Ks='
WHERE
key_id = 'a79701eeabd7f81f8ac1e1477d8019b78235fd695c642123748d64a8c2c0036e'
AND (
token = '2CxJe1U+cIRDYhccbgDUqrZJ59dPtFc/hq4apG42/Ks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)