UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tqscXYzNswga58TxrG0QQUJ4YmywaOAFf7ucemUvpWE='
WHERE
key_id = 'c0063a54b591516826f377c1956d50d8cfbe86020bb100be1c3831cf6dd2d249'
AND (
token = 'tqscXYzNswga58TxrG0QQUJ4YmywaOAFf7ucemUvpWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)