UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5On3LYAPPEFeqGe3b1SoPz1qYG3L5EmcohgR16dxP3Q='
WHERE
key_id = '9f2d9e6ca5e04057a686c80d635fe96a7743988056df58a283d4f9c7e840b006'
AND (
token = '5On3LYAPPEFeqGe3b1SoPz1qYG3L5EmcohgR16dxP3Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)