UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '13v5a6MayxDNYZdaW83nPwoZPDygxV8fNoATH0iucI4='
WHERE
key_id = '1f47423b53f76b1f013dc692794a76d829d24daa48378811c89d5417bd3380a8'
AND (
token = '13v5a6MayxDNYZdaW83nPwoZPDygxV8fNoATH0iucI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)