UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wHAcV442DBlKH1Fe4jFxA9DZ+5LrJaFGM1U4qiQ7778='
WHERE
key_id = 'a729142c261a66d48731d5a92fd309c71a296b0aa53e7aeb8ed72573702b0c0a'
AND (
token = 'wHAcV442DBlKH1Fe4jFxA9DZ+5LrJaFGM1U4qiQ7778='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)