UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L/8h6PB2nd80axpHkNt65BMwLJCjaudL0cuF4YAfJks='
WHERE
key_id = 'fb0f984f308d2cfaeb3738f66cd3e6d7dd2fdf1ec4ce1e9f1709e505f08eedd7'
AND (
token = 'L/8h6PB2nd80axpHkNt65BMwLJCjaudL0cuF4YAfJks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)