UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oLNXVfDlW0tn8lXJtc+W2p3AUgGueFXzd+IlZr13coM='
WHERE
key_id = '9d4b18ae58d9ce5271c57e3e4675103ee559e97f41a516a8058183d784bc2a40'
AND (
token = 'oLNXVfDlW0tn8lXJtc+W2p3AUgGueFXzd+IlZr13coM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)