UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Wj44EvaUlycYBadubkayn40gOurrkFRXEi+t9Ad78dM='
WHERE
key_id = 'efecb2461032247b4edbc1378d01f4a6de5e245028ff59eb1794c6b9481b7d1b'
AND (
token = 'Wj44EvaUlycYBadubkayn40gOurrkFRXEi+t9Ad78dM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)