UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5LEgx1E5zhK4KCRbdeItF9KHhFY53BUG7Ef7faZJodU='
WHERE
key_id = '59dd78fdff94b6ee665d8f475b70173d0809841d19ebe2c8fb8130d66af9589a'
AND (
token = '5LEgx1E5zhK4KCRbdeItF9KHhFY53BUG7Ef7faZJodU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)