UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ng6ZEgFP2txD881mwHrZVbSUfAjxNN5esAu69pw6q+4='
WHERE
key_id = 'd83840a7c4d72c5a23ba122b474ff96911f96ee37589e7ca11e617212211a3a9'
AND (
token = 'ng6ZEgFP2txD881mwHrZVbSUfAjxNN5esAu69pw6q+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)