UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7FZc2tVZ7GgKAdlCQ31Rw9N/IjVoEC1/infmflAc3hQ='
WHERE
key_id = '0f8584d3d17e72d6805499423b9e3ff7ea0a19490f82d4a31e68ef88983af4a9'
AND (
token = '7FZc2tVZ7GgKAdlCQ31Rw9N/IjVoEC1/infmflAc3hQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)