UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B/sh7f7ZZ+0VITnitcV/6PniKwV42R5rlkVbXaICvuo='
WHERE
key_id = '34d7fea106e1759ae35f7cecdfc836f5bf58f82bdc92f3a5a0f8f1f87db96b28'
AND (
token = 'B/sh7f7ZZ+0VITnitcV/6PniKwV42R5rlkVbXaICvuo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)