UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pEx8D6GhD2c6xO8uJH96cA803pHkzjYlSxC6eQwrN50='
WHERE
key_id = '6b3c39163d722aae4932e54086e6be09985c65fa43c206198bb2b0bdfd986ab6'
AND (
token = 'pEx8D6GhD2c6xO8uJH96cA803pHkzjYlSxC6eQwrN50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)