UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XSojxdk+KRp9v4hGxgHWAE7UgNXUFmYYMCmx17Q+FDY='
WHERE
key_id = 'f67534c008b888626274808a171a19d9ef0728c8895e4e5d247225ed552620d0'
AND (
token = 'XSojxdk+KRp9v4hGxgHWAE7UgNXUFmYYMCmx17Q+FDY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)