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