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