UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7i1/1m2h8AiDEzcRbA5y8wfG9tYBza1+jpY4pfBc/Q8='
WHERE
key_id = 'a3cf4dedb03ec5f2b799d2a8b97ec6805b79aab4d4a2c0800fdf4731a6b5d887'
AND (
token = '7i1/1m2h8AiDEzcRbA5y8wfG9tYBza1+jpY4pfBc/Q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)